USE [stockfinder]
GO

/****** Object:  Table [dbo].[DailyPrice]    Script Date: 30/05/2013 13:55:03 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[PriceData](
	[SymbolId] [int] NOT NULL,
	[Open] [decimal](16, 2) NOT NULL,
	[High] [decimal](16, 2) NOT NULL,
	[Low] [decimal](16, 2) NOT NULL,
	[Close] [decimal](16, 2) NOT NULL,
	[Volume] [bigint] NOT NULL,
	[PriceDate] [datetime] NOT NULL,
	[AdjustedClose] [decimal](16, 2) NOT NULL,
	[AdjustedOpen] [decimal](16, 2) NOT NULL,
	[AdjustedHigh] [decimal](16, 2) NOT NULL,
	[AdjustedLow] [decimal](16, 2) NOT NULL,

	[MovingAverage50] [decimal](16, 2) NOT NULL,
	[MovingAverage200] [decimal](16, 2) NOT NULL,
	[Atr20] [decimal](16, 2) NOT NULL,
	[AtrPercentClose20] [decimal](16, 2) NOT NULL,
	[AverageVolume22] [decimal](16, 2) NOT NULL,

	[PercentFromAverageVolume22] [decimal](16, 2) NOT NULL,
	[AverageVolume66] [decimal](16, 2) NOT NULL,
	[PercentFromAverageVolume66] [decimal](16, 2) NOT NULL,
	[High52Week] [decimal](16, 2) NOT NULL,
	[Low52Week] [decimal](16, 2) NOT NULL,

	[Rsi14] [decimal](16, 2) NOT NULL,
	[Rsi20] [decimal](16, 2) NOT NULL,
	[DonchianUpper10] [decimal](16, 2) NOT NULL,
	[DonchianUpper20] [decimal](16, 2) NOT NULL,
	[DonchianUpper55] [decimal](16, 2) NOT NULL,

	[DonchianLower10] [decimal](16, 2) NOT NULL,
	[DonchianLower20] [decimal](16, 2) NOT NULL,
	[DonchianLower55] [decimal](16, 2) NOT NULL,
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[PriceData] ADD  CONSTRAINT [DF_PriceData_AdjustedClose]  DEFAULT ((0)) FOR [AdjustedClose]
GO


